﻿CREATE proc editquyen_loadluoiusercopy  
@MaNhom int  ,
@ID int
as  
select a.ID,a.UserID,b.MaNV,b.TenNV 
from QuanTri_PhanNhomNguoiDung a ,DanhMuc_NguoiDung b
Where a.MaNhomUser=@MaNhom and a.UserID=b.UserID and a.ID <> @ID
order by MaNV